package com.qcby.mycommunity_003.mapper;

import com.qcby.mycommunity_003.entity.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 系统用户 Mapper 接口
 * </p>
 *
 * @author admin
 * @since 2024-03-23
 */
@Mapper
public interface UserMapper extends BaseMapper<User> {
   @Select({"SELECT role_name FROM role r,user_role ur WHERE ur.user_id=#{userId} AND ur.role_id = r.role_id"})
    String selectRolenme(Integer userId);
}
